CreatePreparedStatement Method (Remote Data)

       

Creates a new rdoPreparedStatement object.

Syntax

Set prepstmt = connection.CreatePreparedStatement(name, sqlstring)

The CreatePreparedStatement method syntax has these parts:

Part Description
prepstmt An object expression that evaluates to the rdoPreparedStatement object you want to create.
connection An object expression that represents the open rdoConnection object.
name A String that is the name of the new rdoPreparedStatement. This part is required, but may be an empty string (“”).
sqlstring A Variant expression (a valid SQL statement) that defines the rdoPreparedStatement. This part is required, but you can provide an empty string — if you do, you must define the rdoPreparedStatement by setting its SQL property before executing the new rdoPreparedStatement.

Remarks

Note   Support for the rdoPreparedStatement object is provided in this version of Visual Basic to provide compatibility with previous versions. The rdoQuery object should be used as a direct replacement for this object. Because of this, it is also recommended that use of the CreatePreparedStatement method be discontinued in favor of the CreateQuery method.